UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PD1DyfUd1u5nPV9vr4AsEeG/yBJ7C0g2fcs9jS8hMjw='
WHERE
key_id = '3c49c622d3470d0f28a0b48a97b9d5f571134be99719a5a25276b91ec3640f7b'
AND (
token = 'PD1DyfUd1u5nPV9vr4AsEeG/yBJ7C0g2fcs9jS8hMjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)