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