UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gmjhA2zOANY+Qw+zyy+lWj9/3c2n4dz1aMfn60d2Oqc='
WHERE
key_id = 'f520f129786890355bf771400a2f3f4110c30671be06653008f3684cf20147f9'
AND (
token = 'gmjhA2zOANY+Qw+zyy+lWj9/3c2n4dz1aMfn60d2Oqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)