UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OFb03bfcktVhnBVq3ypHYaA48TZnX93PgBaIg98XhbM='
WHERE
key_id = 'a520153d9e1b2a1c5715913ae5108b8fe7d51fc93f6de59ec14e57c7bfc5ef0e'
AND (
token = 'OFb03bfcktVhnBVq3ypHYaA48TZnX93PgBaIg98XhbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)