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