UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5MEcjruwxoVapwgzSi0xeKBVhyRaB4HyaJiLa3SqGsI='
WHERE
key_id = 'bff1be28e4f5cfa366396c2b9d9d5b71e5730ab26fca1c5bb9aecec4c98ca0dc'
AND (
token = '5MEcjruwxoVapwgzSi0xeKBVhyRaB4HyaJiLa3SqGsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)