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