UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rBBWMwbEDO41PJwO/7bysuDzNs0OaIxd6DsutkM4j80='
WHERE
key_id = '00509c4c520c7dff0b1691de6f8bf6b365aa3f28fc8a5f62c248e92e0ac57267'
AND (
token = 'rBBWMwbEDO41PJwO/7bysuDzNs0OaIxd6DsutkM4j80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)