UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5a+jk6rzsVPTi+Y/XXNIXZc9WKtixj+vwBgsRvJtcwI='
WHERE
key_id = 'db71007caf78029c541047b7bd0ecda5d91d87d11daa4c74a2b829d0b6a89c3a'
AND (
token = '5a+jk6rzsVPTi+Y/XXNIXZc9WKtixj+vwBgsRvJtcwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)