UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+RWj68gD70zn6bqW4Q+i8ox4rEWEti3D3cGPYfgfDQ='
WHERE
key_id = '05c272d4e978914d1d2dd6443746f5ae9f3a00af704f1127f2fb8ae85437af11'
AND (
token = '7+RWj68gD70zn6bqW4Q+i8ox4rEWEti3D3cGPYfgfDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)