UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQQYSBWGWlB1yrSHImjI/zL7aWbeGSXru7/dVb13nQ0='
WHERE
key_id = '2e31290b783deb6c32cd31c3937eade99044afe49fe6dbe87120843e422cc111'
AND (
token = 'HQQYSBWGWlB1yrSHImjI/zL7aWbeGSXru7/dVb13nQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)