UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7lZcN6PVHxAHK4JmjNPuwk3SZhFpdXtRoSaAXh08FXc='
WHERE
key_id = '9a7ea189b4d9f804e9ffd77ca6c323fd7b52ca46206d3ad701ccf6bdf1c3b0ad'
AND (
token = '7lZcN6PVHxAHK4JmjNPuwk3SZhFpdXtRoSaAXh08FXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)