UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2iDmm7/5yKNLfMV8ml+P8Px/QImA01+quQOyf+5scu0='
WHERE
key_id = 'aa18de4e9936450c54a8e8f1202820f1ba607899ea3cd3017a8bc1e6334f1e5a'
AND (
token = '2iDmm7/5yKNLfMV8ml+P8Px/QImA01+quQOyf+5scu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)