UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oihbxpdaAvoKUbYCe5tw8haOX6L9xWhglnkh914EJfI='
WHERE
key_id = '1de249ee1d6e0e5f3bd1a35774cc532d0baf03fdb74125df724190aaf5053a1f'
AND (
token = 'oihbxpdaAvoKUbYCe5tw8haOX6L9xWhglnkh914EJfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)