UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uO0uiS1KuYgjBYTOBbJBjgqE/HY18WUQnKp9a9v4QcM='
WHERE
key_id = 'b2eafa34483f03daa2af5c27e6c67f7fe5b41a4a3041b9a54f507de93ebe233d'
AND (
token = 'uO0uiS1KuYgjBYTOBbJBjgqE/HY18WUQnKp9a9v4QcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)