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