UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MiDlflEF49+xYDunfCvo7iBJbWRUqoocBLd5VjLR98A='
WHERE
key_id = 'ab64018e2ad29c434761b7549631e50df57b031e2d79a63c2f79e2c38d579577'
AND (
token = 'MiDlflEF49+xYDunfCvo7iBJbWRUqoocBLd5VjLR98A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)