UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xkxyPSo0CY1gcaVa3TDst4YuN2ddgB6Kz7WNQHr5t0='
WHERE
key_id = '9b7b05ada60342643ce31e76a5ccc2c6509c446df64fca2d694b99164a2d3440'
AND (
token = '4xkxyPSo0CY1gcaVa3TDst4YuN2ddgB6Kz7WNQHr5t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)