UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBuo32sHPrSq34w2m+RhReKLaxSHTC0YfzzP3bLvXRw='
WHERE
key_id = '58974815c13c3f39f732c27d5091d1a1fa9866e89903a355be28b4ced27db67a'
AND (
token = 'UBuo32sHPrSq34w2m+RhReKLaxSHTC0YfzzP3bLvXRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)