UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZg3ISGNGg6ZBo6Pjs3jl27enXXcoGNHrW7/BxJ1tW8='
WHERE
key_id = 'db39045badd559043eaf815462ca67f9afe299de9e63b2855bd06d331a759b2e'
AND (
token = 'oZg3ISGNGg6ZBo6Pjs3jl27enXXcoGNHrW7/BxJ1tW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)