UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8kQm/jkxv1jhHyxKYIzBjv/iN4goyEXi+r12jXJMWk='
WHERE
key_id = '565c6ced75ce1cae0c11a915929db81acc6bc59eb58a9403d269e5fae70e1875'
AND (
token = 'u8kQm/jkxv1jhHyxKYIzBjv/iN4goyEXi+r12jXJMWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)