UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5o1FmX2sE928kG6hwYk6UoH8vbd5+PzI0uwvBrL5MOw='
WHERE
key_id = '6be41facdce1f409476b8c1a90c6540ddd1ef2c11d491df9b135fcbe77666661'
AND (
token = '5o1FmX2sE928kG6hwYk6UoH8vbd5+PzI0uwvBrL5MOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)