UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8qCPsJmiMtI6kyijhQFDqCU55wDvGVawfetjX21pyw='
WHERE
key_id = '22e04a0875b210716901f1d1d78b1eab02f0d86e8b8b6f3d76a996d64a680583'
AND (
token = 'G8qCPsJmiMtI6kyijhQFDqCU55wDvGVawfetjX21pyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)