UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfSfOKIWmtCNuxBu7EYPHS/N5NQHUgLnzgP8VOIf/jc='
WHERE
key_id = '960ad46eb46e27dc39c97adf760972293704d14a5c58e899850e7804f4750c81'
AND (
token = 'pfSfOKIWmtCNuxBu7EYPHS/N5NQHUgLnzgP8VOIf/jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)