UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLotvVK/mZNV2qQnyeLMI/ClHkBjoDCY/JtVVi2Rd2s='
WHERE
key_id = '8729af807659a6da8590d57278456a1a2f87c2c1659fe3e989c57a6b08fe4231'
AND (
token = 'ZLotvVK/mZNV2qQnyeLMI/ClHkBjoDCY/JtVVi2Rd2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)