UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmJzEHCSFCgJkExyIYmD/RcOF5eFshNOV0XVltDD9M0='
WHERE
key_id = '072d67b2db87aae12189ee776dcf86e1165204938a5b48e2e72b2aae86255ae9'
AND (
token = 'fmJzEHCSFCgJkExyIYmD/RcOF5eFshNOV0XVltDD9M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)