UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brwdmhDHjael4ElU8qkrRVOkaX2ck6bdsHjLX5uhCPI='
WHERE
key_id = 'd1978b2ed37da44dd6ecd240d245d5d9e1804aabd90e9e8a4c7aa837de7ffb69'
AND (
token = 'brwdmhDHjael4ElU8qkrRVOkaX2ck6bdsHjLX5uhCPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)