UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrh6nZ4KQskEEnL6ssFDZ+7/TeEzkf5iDxaWVYiCaMI='
WHERE
key_id = '4fc94e954982af61e8ae5bce80b99aa20a987067a7caefc9f7d4ea61fd31828a'
AND (
token = 'zrh6nZ4KQskEEnL6ssFDZ+7/TeEzkf5iDxaWVYiCaMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)