UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LgghN+jc2nM0MbDNvE6DXVqnjXz+OSYMaWKUpuIf3vU='
WHERE
key_id = 'c9c9bde6b538304c0196cbd26d426efa096e2d0f34940058c86888b36569593f'
AND (
token = 'LgghN+jc2nM0MbDNvE6DXVqnjXz+OSYMaWKUpuIf3vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)