UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BT3DMK8BrLkAVgVWKbYZY9fFAJf9GJDz7IjMN+zgJk='
WHERE
key_id = '7f8fa2331623e02fc032ac80a048555916e9e0d3df4e5420dbbaa3f4d001ce7b'
AND (
token = '1BT3DMK8BrLkAVgVWKbYZY9fFAJf9GJDz7IjMN+zgJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)