UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8+a7s7o7jV4xRnzwgHMFvTMD0UtuBbHXMc/lsjIHfA='
WHERE
key_id = '28b292306687b57275331e32defa78a3d7be24d8e7ba5a72d0b48a6318d1039e'
AND (
token = 'p8+a7s7o7jV4xRnzwgHMFvTMD0UtuBbHXMc/lsjIHfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)