UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cqKHe4aOR08JH/B4xqj3cq46g/RvPn/XSEV09upuGY='
WHERE
key_id = '30b8d364afbc1add0ac94c7dcce02dffe1508c43606ece804b353fadb78b0ed2'
AND (
token = '0cqKHe4aOR08JH/B4xqj3cq46g/RvPn/XSEV09upuGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)