UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSPLgrCnoUYs31XxRd0bqdEOuW168/Hvjw3B7HxLwo8='
WHERE
key_id = '6f127532498652992c413d1ecffdf1c2a6e5f94d31ced0f54f93b843bdb58d1e'
AND (
token = 'zSPLgrCnoUYs31XxRd0bqdEOuW168/Hvjw3B7HxLwo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)